from common.setting import ensure_path_sep
from utils.mysqlUtils.db_pool import Database

zhcxkj_center_strategy_comprehensive_db= Database(ensure_path_sep("\\config\\shopeev2_config.yaml.bak"), "test_jdw_database")




class T_strategy_import_filter_allegro:


    @staticmethod
    def get_t_strategy_import_filter_allegro_by_strategy_id(strategy_id):
        get_specify_list = f"""
        select import_val,rule_code
        from test_zhcxkj_center_strategy_comprehensive.t_strategy_import_filter_allegro
        where import_id =%s
        """
        specify_list = zhcxkj_center_strategy_comprehensive_db.fetch_all_tuple(get_specify_list, (strategy_id,))
        return specify_list